Note   Synchronizing and converting Access database files is available only on devices running Windows Mobile software for Pocket PC 2003 and earlier.

• Three types of indexes are converted in the following order:
  1. Primary key indexes

     A primary key index will be converted to a non-primary key index. When a table contains a primary key consisting of multiple fields, the table will not be converted.

  2. Unique indexes

     These indexes are converted to non-unique indexes. When a Unique index consists of more than one field, only the first field is converted.

  3. Non-unique indexes

     When a non-unique index consists of more than one field, it will not be converted.

• Indexes with names longer than 64 characters are converted with truncated names. If an index already exists in a table with that truncated name, the new index will not be converted.
• Indexes are only converted with the attributes of ascending or descending.
• Index titles are converted with case sensitivity retained.
• Indexes for fields that contain information Pocket Access can't interpret (for example, images and OLE objects) will not be converted.
• Fields with more than one index are converted with only one index.
• Fields with a Boolean data type are converted without an index.

See also

Database field and table conversion to Pocket Access